create database TestDB
on
(
name='Students',
filename='E:\Backup\Students.mdf',
size=6MB,
filegrowth=1MB,
maxsize=100MB
),
filegroup group1
(
name='Students1',
filename='E:\Backup\Students.ndf',
size=6MB,
filegrowth=1MB,
maxsize=100MB
)
log on
(
name='Students_log',
filename='E:\Backup\Students_log.ldf',
size=6MB,
filegrowth=1MB,
maxsize=100MB
)
go

use TestDB
use master
drop database TestDB

go

create database Company
on(
name='Studente',
size=5MB,
filegrowth=2MB,
maxsize=50MB,
filename='E:\Backup\Studente_mdf'
)
,
filegroup group1
(name='Studente1',
size=5MB,
filegrowth=2MB,
maxsize=50MB,
filename='E:\Backup\Studente_ndf'
)
log on
(name='Studente_log',
size=5MB,
filegrowth=2MB,
maxsize=50MB,
filename='E:\Backup\Studente_log.ldf'
)
go
use Company
backup database Company
to disk='E:\Backup\Company20210303.bak'

use master
restore database Company
from disk='E:\Backup\Company20210303.bak'
